
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspSiteContentType_INSERT]
(
@code AS int = null,
@name AS nvarchar(100) = null,
@targetPage AS nvarchar(100) = null
)
AS

INSERT INTO
  [dbo].[SiteContentType]
(
  [Code],
  [Name],
  [TargetPage]
)
VALUES
(
  @code,
  @name,
  @targetPage
)

SELECT SCOPE_IDENTITY()

GO
